{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes Balance","Cumulative Defaults","Collateral Tables"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":5,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes Balance","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C3:F3)","v":408900000},189325000,200000000,10875000,8700000]
["Invested Amount as at Previous Payment Date:  17 August 2020",{"$f":"SUM(C4:F4)","v":408900000},189325000,200000000,10875000,8700000]
["Stated Amount as at Previous Payment Date:  17 August 2020",408900000,189325000,200000000,10875000,8700000]
["Principal Payments to Noteholders on Payment Date",34777204.240000002,34777204.240000002,0,0,0]
["Gross Aggregate Charge-Offs",{"$f":"SUM(C7:G7)","v":0},0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 November 2020",374122795.75999999,154547795.75999999,200000000,10875000,8700000]
["Stated Amount as at Payment Date:  16 November 2020",374122795.75999999,154547795.75999999,200000000,10875000,8700000]
["Bond Factor at Payment Date:  16 November 2020",null,0.8163094982701703,1,1,1]
["Coupon Margin",null,9.4999999999999998E-3,1.0999999999999999E-2,0,0]
["Coupon Rate (3 month BBSW + margin)",null,1.0499999999999999E-2,1.2E-2,1E-3,1E-3]
["Days in Coupon Period",null,91,91,91,91]
["Coupon Entitlement to be paid out on the current Payment Date: 16 November 2020",null,495616.54,598356.16,2711.3,2169.04]

{"sheet":"Cumulative Defaults","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2020-10-01",{"$f":"+'Collateral Tables'!E9/435000000","v":0},{"$f":"+'Collateral Tables'!E23/435000000","v":0},{"$f":"+B4-C4","v":0}]

{"sheet":"Collateral Tables","index":2,"n_rows":246,"n_cols":7,"rows_kept":246,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2020-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2020-10-31"]
[]
[null,"Opening Balance",null,null,434999973.20000142]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN(([2]Sheet1!$B$3+[2]Sheet1!$B$4+[2]Sheet1!$B$5+[2]Sheet1!$B$6),'[1]16 Nov 20'!H23)","v":26305441.499999996}]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[1]16 Nov 20'!$H$23-'Collateral Tables'!E7","v":8471735.9399999939}]
[{"$f":"SUM(E9)","v":0},"Charge-Offs",null,null,{"$f":"'[1]16 Nov 20'!$H$37","v":0}]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":400222795.76000142}]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[3]Summary!$B$4","v":3459}]
[null,"Dollar value of contracts",null,null,{"$f":"[3]Summary!$B$5","v":400222795.76000023}]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[3]Summary!$B$19","v":81}]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[3]Summary!$B$20","v":11089284.780000003}]
[]
[{"$f":"SUM(Q23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[3]Summary!$C$16","v":0}]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[4]Sheet1!$W$3461","v":54.458787730372293}]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[4]Sheet1!$X$3461","v":39.320110754577776}]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[4]Sheet1!$AI$3461","v":3.7554148495446298E-2}]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":15.138676975794517}]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":115704.76893899978}]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[4]Sheet1!$AA$3461/100","v":2.2793137532541325E-2}]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A34,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":3448},{"$f":"IFERROR(VLOOKUP($A34,'[5]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":608582.11},{"$f":"F34/F$50","v":1.5206083122885025E-3}]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":8},{"$f":"IFERROR(VLOOKUP($A35,'[5]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":239593.93000000002},{"$f":"F35/F$50","v":5.9865138252563753E-4}]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A36,'[5]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":134580.25},3.3626332988964257E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A37,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A37,'[5]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":5840.8499999999985},1.459399629875794E-5]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A38,'[5]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A39,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A39,'[5]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":3459},{"$f":"SUM(F34:F39)","v":988597.14},{"$f":"SUM(G34:G39)","v":2.4701170210025408E-3}]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":9.4950870871403803E-4}]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A44,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":3448},{"$f":"IFERROR(VLOOKUP($A44,'[5]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":398525593.33000022},{"$f":"F44/F$50","v":0.99575935591880238}]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":8},{"$f":"IFERROR(VLOOKUP($A45,'[5]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":1107284.19},{"$f":"F45/F$50","v":2.7666694694322208E-3}]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A46,'[5]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":543586.31000000006},1.3582092668353904E-3]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A47,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A47,'[5]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":46331.93},{"$f":"F47/F$50","v":1.1576534492998659E-4}]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A48,'[5]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},{"$f":"F48/F$50","v":0}]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,'[5]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A49,'[5]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0}]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":3459},{"$f":"SUM(F44:F49)","v":400222795.76000023},{"$f":"SUM(G44:G49)","v":1}]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":4.2406440811975981E-3}]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":1.1576534492998659E-4}]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.24685968916984516},{"$f":"IFERROR(VLOOKUP($A55,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":98798874.960000023}]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.21323032049672458},{"$f":"IFERROR(VLOOKUP($A56,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":85339635.009999946}]
["QLD","Queensland",null,null,0.10911006482545886,{"$f":"IFERROR(VLOOKUP($A57,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":43668335.189999983}]
["SA","South Australia",null,null,0.2000584061883722,{"$f":"IFERROR(VLOOKUP($A58,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":80067934.640000001}]
["NT","Northern Territory",null,null,0,{"$f":"IFERROR(VLOOKUP($A59,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":0}]
["ACT","Australian Capital Territory",null,null,1.1397817036727404E-3,{"$f":"IFERROR(VLOOKUP($A60,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":456166.62}]
["TAS","Tasmania",null,null,1.5793035821453624E-2,{"$f":"IFERROR(VLOOKUP($A61,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":6320732.9499999974}]
["WA","Western Australia",null,null,0.21380870179447287,{"$f":"IFERROR(VLOOKUP($A62,'[5]Geographic '!$A$1:$C$10,3,FALSE),0)","v":85571116.39000006}]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1},{"$f":"SUM(F55:F62)","v":400222795.75999999}]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":1.430511474609375E-6}]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.96151115188042091},{"$f":"IFERROR(VLOOKUP($A$66,'[5]Top Industry'!$A$1:$C$4,3,FALSE),)","v":384818681.36000061}]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":3.848884811957913E-2},{"$f":"IFERROR(VLOOKUP($A$67,'[5]Top Industry'!$A$1:$C$4,3,FALSE),)","v":15404114.4}]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP($A$68,'[5]Top Industry'!$A$1:$C$4,3,FALSE),)","v":0}]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":1},{"$f":"SUM(F66:F68)","v":400222795.76000059},{"$f":"F63-F69","v":-5.9604644775390625E-7}]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$110,0)","v":0.10041685507614133},{"$f":"IFERROR(VLOOKUP($A72,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":40189114.480000019}]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,9.7749299351403862E-2,{"$f":"IFERROR(VLOOKUP($A73,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":39121497.869999997}]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,9.7833235424900616E-3,{"$f":"IFERROR(VLOOKUP($A74,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":3915509.0999999982}]
["4WD Vehicle","4WD Vehicle",null,null,2.9054124660537806E-3,{"$f":"IFERROR(VLOOKUP($A75,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1162812.2999999998}]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,4.6006634867049409E-2,{"$f":"IFERROR(VLOOKUP($A76,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":18412904.030000005}]
["BACKHOE","BACKHOE",null,null,3.622858606158672E-4,{"$f":"IFERROR(VLOOKUP($A77,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":144995.06}]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,4.0605957487102856E-2,{"$f":"IFERROR(VLOOKUP($A78,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":16251429.830000004}]
["COMBINES","COMBINES",null,null,0.32708290993624445,{"$f":"IFERROR(VLOOKUP($A79,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":130906036.66}]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,5.216192436104731E-3,{"$f":"IFERROR(VLOOKUP($A80,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":2087639.1199999999}]
["COMPACT WHEEL LOADER","COMPACT WHEEL LOADER",null,null,6.7083979934266834E-4,{"$f":"IFERROR(VLOOKUP($A81,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":268485.38000000006}]
["CRAWLER EXCAVATOR","CRAWLER EXCAVATOR",null,null,7.4809969639896279E-3,{"$f":"IFERROR(VLOOKUP($A82,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":2994065.52}]
["CRAWLER  DOZER","CRAWLER  DOZER",null,null,1.9781217071771932E-4,{"$f":"IFERROR(VLOOKUP($A83,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":79168.94}]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.8602632780729052E-2,{"$f":"IFERROR(VLOOKUP($A84,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":7445197.7000000011}]
["DRILL","DRILL",null,null,9.2039425015884085E-4,{"$f":"IFERROR(VLOOKUP($A85,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":368362.76}]
["DUMP TRUCKS","DUMP TRUCKS",null,null,7.2270920863150989E-5,{"$f":"IFERROR(VLOOKUP($A86,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":28924.469999999994}]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,5.266989342766165E-4,{"$f":"IFERROR(VLOOKUP($A87,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":210796.91999999987}]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,1.2643309810454664E-3,{"$f":"IFERROR(VLOOKUP($A88,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":506014.07999999996}]
["FRONT END LOADER","FRONT END LOADER",null,null,6.4381105406728189E-4,{"$f":"IFERROR(VLOOKUP($A89,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":257667.86}]
["FRONTS","FRONTS",null,null,3.7781679255140701E-3,{"$f":"IFERROR(VLOOKUP($A90,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1512108.9300000002}]
["GRADER","GRADER",null,null,0,{"$f":"IFERROR(VLOOKUP($A91,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""}]
["HARVESTERS - Other","HARVESTERS - Other",null,null,1.9737315724357083E-2,{"$f":"IFERROR(VLOOKUP($A92,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":7899323.6799999988}]
["IRRIGATION EQUIPMENT","IRRIGATION EQUIPMENT",null,null,0,{"$f":"IFERROR(VLOOKUP($A93,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""}]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,0,{"$f":"IFERROR(VLOOKUP($A94,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""}]
["MIDI CRAWLER EXCAVATOR","MIDI CRAWLER EXCAVATOR",null,null,1.2680610534346844E-3,{"$f":"IFERROR(VLOOKUP($A95,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":507506.94}]
["MINI EXCAVATOR","MINI EXCAVATOR",null,null,5.1123271629609024E-3,{"$f":"IFERROR(VLOOKUP($A96,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":2046069.8700000008}]
["OTHER AG","OTHER AG",null,null,1.6185151017445894E-2,{"$f":"IFERROR(VLOOKUP($A97,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":6477666.3900000015}]
["OTHER CE","OTHER CE",null,null,0,{"$f":"IFERROR(VLOOKUP($A98,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""}]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.20938034891508597,{"$f":"IFERROR(VLOOKUP($A99,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":83798788.61999996}]
["QUAD BIKES","QUAD BIKES",null,null,2.7407659224333244E-5,{"$f":"IFERROR(VLOOKUP($A100,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":10969.17}]
["ROLLER","ROLLER",null,null,3.9739405322473092E-3,{"$f":"IFERROR(VLOOKUP($A101,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1590461.5899999999}]
["SCRAPERS","SCRAPERS",null,null,0,{"$f":"IFERROR(VLOOKUP($A102,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""}]
["SKID STEER LOADER","SKID STEER LOADER",null,null,9.8631905324232626E-3,{"$f":"IFERROR(VLOOKUP($A103,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":3947473.69}]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,4.90521834537694E-4,{"$f":"IFERROR(VLOOKUP($A104,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":196318.01999999996}]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,6.511955632239573E-2,{"$f":"IFERROR(VLOOKUP($A105,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":26062330.889999993}]
["Telehandlers","Telehandlers",null,null,5.5042499411278427E-4,{"$f":"IFERROR(VLOOKUP($A106,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":220292.63}]
["UNDER 40 HP TRACTORS","UNDER 40 HP TRACTORS",null,null,7.5121752979880811E-4,{"$f":"IFERROR(VLOOKUP($A107,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":300654.38}]
["WHEEL LOADERS","WHEEL LOADERS",null,null,2.9328916354477074E-3,{"$f":"IFERROR(VLOOKUP($A108,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1173810.0899999999}]
["WHEEL LOADERS (OLD)","WHEEL LOADERS (OLD)",null,null,3.2081828261725583E-4,{"$f":"IFERROR(VLOOKUP($A109,[5]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":128398.78999999989}]
[null,"Total",null,null,{"$f":"SUM(E72:E108)","v":0.99967918171738313},{"$f":"SUM(F72:F109)","v":400222795.75999987},{"$f":"F69-F110","v":7.152557373046875E-7}]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F113/F$124,0)","v":2.2574458590854159E-2},{"$f":"IFERROR(VLOOKUP($A113,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":9034812.9300000016}]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F114/F$124,0)","v":7.3033342527365652E-2},{"$f":"IFERROR(VLOOKUP($A114,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":29229608.529999986}]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,7.4956081157329796E-2,{"$f":"IFERROR(VLOOKUP($A115,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":29999132.359999988}]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,6.3864139026522118E-2,{"$f":"IFERROR(VLOOKUP($A116,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":25559884.270000007}]
["$100,001 - $125,000","$100,001 to $125,000",null,null,5.8396196437583939E-2,{"$f":"IFERROR(VLOOKUP($A117,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":23371488.999999996}]
["$125,001 - $150,000","$125,001 to $150,000",null,null,6.5373349762139973E-2,{"$f":"IFERROR(VLOOKUP($A118,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":26163904.809999991}]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.11717379366397136,{"$f":"IFERROR(VLOOKUP($A119,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":46895623.289999992}]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.18750423228016472,{"$f":"IFERROR(VLOOKUP($A120,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":75043468.059999958}]
["$300,001 - $400,000","$300,001 to $400,000",null,null,0.15846960513471778,{"$f":"IFERROR(VLOOKUP($A121,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":63423148.409999996}]
["$400,001 - $500,000","$400,001 to $500,000",null,null,8.834049255705495E-2,{"$f":"IFERROR(VLOOKUP($A122,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":35355878.910000004}]
["$500,001+","$500,000+",null,null,9.0314308862295384E-2,{"$f":"IFERROR(VLOOKUP($A123,'[5] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":36145845.190000005}]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E113:E123)","v":0.99999999999999989},{"$f":"SUM(F113:F123)","v":400222795.75999999},{"$f":"F110-F124","v":0}]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
[0,0,null,null,{"$f":"IFERROR(F127/F$137,0)","v":0.88078069978649454},{"$f":"IFERROR(VLOOKUP($A127,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":352508514.12000066}]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F128/F$137,0)","v":2.95355040373275E-4},{"$f":"IFERROR(VLOOKUP($A128,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":118207.81999999998}]
["6 to 10","06 to 10",null,null,8.4902527692042192E-4,{"$f":"IFERROR(VLOOKUP($A129,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":339799.27}]
["11 to 15","11 to 15",null,null,4.8542276966277833E-3,{"$f":"IFERROR(VLOOKUP($A130,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":1942772.5799999996}]
["16 to 20","16 to 20",null,null,1.286476691119697E-2,{"$f":"IFERROR(VLOOKUP($A131,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":5148772.9799999995}]
["21 to 25","21 to 25",null,null,1.3997083947610249E-2,{"$f":"IFERROR(VLOOKUP($A132,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":5601952.0700000003}]
["26 to 30","26 to 30",null,null,3.8710363737727869E-2,{"$f":"IFERROR(VLOOKUP($A133,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":15492769.999999996}]
["31 to 35","31 to 35",null,null,1.21033420917503E-2,{"$f":"IFERROR(VLOOKUP($A134,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":4844033.4099999992}]
["36 to 40","36 to 40",null,null,2.168696514029865E-2,{"$f":"IFERROR(VLOOKUP($A135,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":8679617.8200000003}]
["41+ %","41+%",null,null,1.3858170370999935E-2,{"$f":"IFERROR(VLOOKUP($A136,'[5]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":5546355.6899999995}]
[null,null,null,null,{"$f":"SUM(E127:E136)","v":1},{"$f":"SUM(F127:F136)","v":400222795.76000065},{"$f":"F124-F137","v":-6.5565109252929688E-7}]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B140,2)&LEFT(B140,4)","v":"Q32020"},"2020Q3",null,null,{"$f":"F140/F$165","v":1.2270372032843649E-3},{"$f":"IFERROR(VLOOKUP($A140,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":491088.26}]
["Q42020","2020Q4",null,null,2.4926624384440078E-3,{"$f":"IFERROR(VLOOKUP($A141,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":997620.32999999984}]
["Q12021","2021Q1",null,null,8.5426130550800197E-3,{"$f":"IFERROR(VLOOKUP($A142,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":3418948.4800000004}]
["Q22021","2021Q2",null,null,1.0496454311211063E-2,{"$f":"IFERROR(VLOOKUP($A143,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":4200920.2899999972}]
["Q32021","2021Q3",null,null,6.3174864270255015E-3,{"$f":"IFERROR(VLOOKUP($A144,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":2528402.0799999996}]
["Q42021","2021Q4",null,null,1.08974425400181E-2,{"$f":"IFERROR(VLOOKUP($A145,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":4361404.92}]
["Q12022","2022Q1",null,null,3.569149606502163E-2,{"$f":"IFERROR(VLOOKUP($A146,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":14284550.339999998}]
["Q22022","2022Q2",null,null,1.8372218593988663E-2,{"$f":"IFERROR(VLOOKUP($A147,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":7352980.6900000004}]
["Q32022","2022Q3",null,null,1.6054907661614513E-2,{"$f":"IFERROR(VLOOKUP($A148,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":6425540.0300000058}]
["Q42022","2022Q4",null,null,1.9000838134567932E-2,{"$f":"IFERROR(VLOOKUP($A149,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":7604568.5600000015}]
["Q12023","2023Q1",null,null,0.1013513524709979,{"$f":"IFERROR(VLOOKUP($A150,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":40563121.639999971}]
["Q22023","2023Q2",null,null,6.0824672752018652E-2,{"$f":"IFERROR(VLOOKUP($A151,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":24343420.580000002}]
["Q32023","2023Q3",null,null,5.2220377228419768E-2,{"$f":"IFERROR(VLOOKUP($A152,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":20899785.370000001}]
["Q42023","2023Q4",null,null,5.972607291048522E-2,{"$f":"IFERROR(VLOOKUP($A153,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":23903735.879999999}]
["Q12024","2024Q1",null,null,0.14245270505328397,{"$f":"IFERROR(VLOOKUP($A154,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":57012819.880000003}]
["Q22024","2024Q2",null,null,4.8966356458495987E-2,{"$f":"IFERROR(VLOOKUP($A155,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":19597452.079999998}]
["Q32024","2024Q3",null,null,6.0697541287896582E-2,{"$f":"IFERROR(VLOOKUP($A156,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":24292539.670000006}]
["Q42024","2024Q4",null,null,9.1743627846771827E-2,{"$f":"IFERROR(VLOOKUP($A157,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":36717891.230000012}]
["Q12025","2025Q1",null,null,0.15410222656828504,{"$f":"IFERROR(VLOOKUP($A158,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":61675223.949999996}]
["Q22025","2025Q2",null,null,6.8632765052373132E-2,{"$f":"IFERROR(VLOOKUP($A159,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":27468397.110000003}]
["Q32025","2025Q3",null,null,9.0540980133799864E-3,{"$f":"IFERROR(VLOOKUP($A160,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":3623656.4200000004}]
["Q42025","2025Q4",null,null,7.0127581430495566E-3,{"$f":"IFERROR(VLOOKUP($A161,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":2806665.67}]
["Q12026","2026Q1",null,null,1.0797898509987662E-2,{"$f":"IFERROR(VLOOKUP($A162,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":4321565.1300000008}]
["Q22026","2026Q2",null,null,3.3243912742987624E-3,{"$f":"IFERROR(VLOOKUP($A163,'[5]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":1330497.17}]
[]
[null,null,null,null,{"$f":"SUM(E140:E160)","v":0.97886495207266389},{"$f":"SUM(F140:F163)","v":400222795.76000005},{"$f":"F137-F165","v":5.9604644775390625E-7}]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F168/F$179","v":5.2921023001151188E-2},{"$f":"IFERROR(VLOOKUP($A168,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":21180199.780000005}]
["07 to 12 months","07 to 12 months",null,null,{"$f":"F169/F$179","v":0.40941777648832445},{"$f":"IFERROR(VLOOKUP($A169,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":163858327.1400001}]
["13 to 18 months","13 to 18 months",null,null,0.24702825238192275,{"$f":"IFERROR(VLOOKUP($A170,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":98866337.800000057}]
["19 to 24 months","19 to 24 months",null,null,2.7472922348464868E-2,{"$f":"IFERROR(VLOOKUP($A171,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":10995289.790000001}]
["25 to 30 months","25 to 30 months",null,null,0.2389215961285252,{"$f":"IFERROR(VLOOKUP($A172,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":95621869.170000002}]
["31 to 36 months","31 to 36 months",null,null,4.9692256939622528E-4,{"$f":"IFERROR(VLOOKUP($A173,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":198879.74}]
["37 to 42 months","37 to 42 months",null,null,2.8756331778016751E-3,{"$f":"IFERROR(VLOOKUP($A174,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":1150893.9500000002}]
["43 to 48 months","43 to 48 months",null,null,1.93323172042398E-2,{"$f":"IFERROR(VLOOKUP($A175,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":7737234.0400000047}]
["49 to 54 months","49 to 54 months",null,null,1.5335567001737037E-3,{"$f":"IFERROR(VLOOKUP($A176,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":613764.35000000009}]
["55 to 60 months","55 to 60 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A177,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0}]
["60+ months","61 to 72 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A178,'[5]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0}]
["61 to 72 months","Total",null,null,{"$f":"SUM(E168:E178)","v":0.99999999999999989},{"$f":"SUM(F168:F178)","v":400222795.76000023},{"$f":"F165-F179","v":0}]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F182/F$188","v":3.1444269999919311E-2},{"$f":"IFERROR(VLOOKUP($A182,'[5]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":12584713.650000002}]
["13 - 24 months","13-24 Months",null,null,{"$f":"F183/F$188","v":8.7396246991825743E-2},{"$f":"IFERROR(VLOOKUP($A183,'[5]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":34977970.309999995}]
["25 - 36 months","25-36 Months",null,null,0.25470614312816287,{"$f":"IFERROR(VLOOKUP($A184,'[5]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":101939204.70000008}]
["37 - 48 months","37-48 Months",null,null,0.3246945979257182,{"$f":"IFERROR(VLOOKUP($A185,'[5]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":129950179.75000006}]
["49 - 60 months","49-60 Months",null,null,0.28525330568241963,{"$f":"IFERROR(VLOOKUP($A186,'[5]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":114164875.4999999}]
["60+ Months","60+ Months",null,null,1.6505436271954142E-2,{"$f":"IFERROR(VLOOKUP($A187,'[5]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":6605851.8499999996}]
[null,null,null,null,{"$f":"SUM(E182:E187)","v":0.99999999999999978},{"$f":"SUM(F182:F187)","v":400222795.76000005},{"$f":"F179-F188","v":0}]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F191/F$207","v":4.3081004337242772E-4},{"$f":"IFERROR(VLOOKUP($A191,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":172420}]
["02. 21% to 30%","21% to 30%",null,null,4.5007721176386567E-3,{"$f":"IFERROR(VLOOKUP($A192,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":1801311.6}]
["03. 31% to 40%","31% to 40%",null,null,2.3761402175858894E-2,{"$f":"IFERROR(VLOOKUP($A193,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":9509854.8100000005}]
["04. 41% to 50%","41% to 50%",null,null,6.3449995100299014E-2,{"$f":"IFERROR(VLOOKUP($A194,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":25394134.429999992}]
["05. 51% to 60%","51% to 60%",null,null,0.1322238800503851,{"$f":"IFERROR(VLOOKUP($A195,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":52919010.940000057}]
["06. 61% to 70%","61% to 70%",null,null,0.16101709436022255,{"$f":"IFERROR(VLOOKUP($A196,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":64442711.670000046}]
["07. 71% to 80%","71% to 80%",null,null,0.19027833213595022,{"$f":"IFERROR(VLOOKUP($A197,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":76153726.059999898}]
["08. 81% to 90%","81% to 90%",null,null,0.17702756954525525,{"$f":"IFERROR(VLOOKUP($A198,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":70850468.809999943}]
["09. 91% to 100%","91% to 100%",null,null,0.2473101444710171,{"$f":"IFERROR(VLOOKUP($A199,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":98979157.440000042}]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A200,'[5]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":0}]
[null,null,null,null,{"$f":"SUM(E191:E200)","v":0.99999999999999911},{"$f":"SUM(F191:F200)","v":400222795.75999999},{"$f":"F188-F201","v":0}]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F204/F$207","v":0.85077110039025661},{"$f":"IFERROR(VLOOKUP($A204,'[5]New v Used'!$A$1:$C$9,3,FALSE),0)","v":340497988.35000038}]
["USed","Used",null,null,{"$f":"F205/F$207","v":0.14922889960974342},{"$f":"IFERROR(VLOOKUP($A205,'[5]New v Used'!$A$1:$C$9,3,FALSE),0)","v":59724807.409999929}]
["Used"]
[null,null,null,null,{"$f":"SUM(E204:E205)","v":1},{"$f":"SUM(F204:F205)","v":400222795.76000029},{"$f":"F201-F207","v":0}]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F210/F$213","v":1.2173266069835714E-2},{"$f":"IFERROR(VLOOKUP($A210,'[5]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":4872018.58}]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F211/F$213","v":0.98782673393016429},{"$f":"IFERROR(VLOOKUP($A211,'[5]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":395350777.18000031}]
["Hire Purchase","Hire Purchase",null,null,0,{"$f":"IFERROR(VLOOKUP($A212,'[5]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":0}]
[null,null,null,null,{"$f":"SUM(E210:E212)","v":1},{"$f":"SUM(F210:F212)","v":400222795.76000029},{"$f":"F207-F213","v":0}]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F216/F$218","v":0.99978193865785614},{"$f":"IFERROR(VLOOKUP($A216,'[5]Refinance vs Hardship'!$A$1:$C$7,3,FALSE),0)","v":400135522.64000022}]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F217/F$218","v":2.18061342143876E-4},{"$f":"IFERROR(VLOOKUP($A217,'[5]Refinance vs Hardship'!$A$1:$C$7,3,FALSE),0)","v":87273.12000000001}]
[null,null,null,null,{"$f":"SUM(E216:E217)","v":1},{"$f":"SUM(F216:F217)","v":400222795.76000023},{"$f":"F213-F218","v":0}]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F221/F$227","v":1.4772097473291602E-2},{"$f":"IFERROR(VLOOKUP($A221,'[5]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":5912130.1499999985}]
["Annual","Annual",null,null,0.71645348817649301,{"$f":"IFERROR(VLOOKUP($A222,'[5]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":286741018.07000023}]
["Monthly","Monthly",null,null,0.20566461051698665,{"$f":"IFERROR(VLOOKUP($A223,'[5]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":82311665.409999922}]
["Quarterly","Quarterly",null,null,1.1422122998564301E-2,{"$f":"IFERROR(VLOOKUP($A224,'[5]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":4571394}]
["Semi Annual","Semi Annual",null,null,2.9764271191447641E-2,{"$f":"IFERROR(VLOOKUP($A225,'[5]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":11912339.830000004}]
["Structured","Structured",null,null,2.192340964321687E-2,{"$f":"IFERROR(VLOOKUP($A226,'[5]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":8774248.3000000026}]
["0% to 1%",null,null,null,{"$f":"SUM(E221:E226)","v":1},{"$f":"SUM(F221:F226)","v":400222795.76000011},{"$f":"F218-F227","v":0}]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F230/F$244","v":0.23484566253033451},{"$f":"IFERROR(VLOOKUP($A230,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":93990587.629999965}]
["02. 1.01% to 2%",null,null,null,0.2247556444134714,{"$f":"IFERROR(VLOOKUP($A231,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":89952332.36999996}]
["03. 2.01% to 3%",null,null,null,0.27802326811170847,{"$f":"IFERROR(VLOOKUP($A232,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":111271249.65000004}]
["04. 3.01% to 4%",null,null,null,0.18157180505424597,{"$f":"IFERROR(VLOOKUP($A233,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":72669175.450000033}]
[null,"< 4%",null,null,{"$f":"SUM(E230:E233)","v":0.91919638010976035},{"$f":"SUM(F230:F233)","v":367883345.10000002}]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F235/F$244","v":5.8066183626221748E-2},{"$f":"IFERROR(VLOOKUP($A235,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":23239410.350000005}]
["06. 5.01% to 6%","5% to 6%",null,null,2.1903905506814106E-2,{"$f":"IFERROR(VLOOKUP($A236,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":8766442.3000000026}]
["07. 6.01% to 7%","6% to 7%",null,null,7.9430965294299306E-4,{"$f":"IFERROR(VLOOKUP($A237,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":317900.83}]
["08. 7.01% to 8%","7% to 8%",null,null,3.9221104260670507E-5,{"$f":"IFERROR(VLOOKUP($A238,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":15697.18}]
["09. 8.01% to 9%","8% to 9%",null,null,0,{"$f":"IFERROR(VLOOKUP($A239,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0}]
["10. 9.01% to 10%","9% to 10%",null,null,0,{"$f":"IFERROR(VLOOKUP($A240,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0}]
["11. 10.01% to 11%","10% to 11%",null,null,0,{"$f":"IFERROR(VLOOKUP($A241,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0}]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A242,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0}]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A243,'[5]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0}]
[null,null,null,null,{"$f":"SUM(E234:E243)","v":0.99999999999999989},{"$f":"SUM(F234:F243)","v":400222795.76000005},{"$f":"F227-F244","v":0}]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F246/E13","v":2.2380875639505995E-2},{"$f":"SUM('[5]Top 5 Obligor '!$E$2:$E$6)","v":8957336.6199999992}]